StudentAreaOfStudy

EntityType | Independent
Logical Entity Name | StudentAreaOfStudy
Default Table Name | AdConcentrationByEnrollment
Logical Only | NO
Owner | dbo
Definition |
Note |

StudentAreaOfStudy Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
StudentEnrollmentPeriodId |  | INTEGER | NO |
AreaOfStudyId |  | INTEGER | YES |
StudentAreaOfStudyId |  | INTEGER | NO |
LastModifiedUserId |  | INTEGER | NO |
CreatedDateTime |  | DATETIME | NO |
LastModifiedDateTime |  | DATETIME | NO |
RowVersion |  | TIMESTAMP/DATE | NO |
IsActive |  | BIT | NO |
DropDate |  | DATETIME | YES |
GPA |  | NUMERIC(11, 6) | YES |
StudentAreaOfStudyParentId |  | INTEGER | YES |
ProgramVersionAreaOfStudyId |  | INTEGER | YES |
CreatedByUserId |  | INTEGER | NO |
DropByUserId |  | INTEGER | YES |
IsExcludedCrmIntegration |  | BIT | NO |

StudentAreaOfStudy Keys

Key Name | Key Type | Keys
AdConcentrationByEnrollment_AdEnrollID_Include_N_N_IDX | Inversion Entry | StudentEnrollmentPeriodId
AdConcentrationByEnrollment_Active_AdEnrollID_AdConcentrationID_N_N_IDX | Inversion Entry | IsActive, StudentEnrollmentPeriodId
AdConcentrationByEnrollment_AdConcentrationByEnrollmentID_U_C_IDX | PrimaryKey | StudentAreaOfStudyId
AdConcentrationByEnrollment_AdConcentrationByProgramVersionID_N_N_IDX | Inversion Entry | ProgramVersionAreaOfStudyId
AdConcentrationByEnrollment_UserID_N_N_IDX | Inversion Entry | LastModifiedUserId

StudentAreaOfStudy Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
ProgramVersionAreaOfStudy | Non-Identifying | Zero or One to Zero or More |  |  |  | ProgramVersionAreaOfStudyId | NO
StudentAreaOfStudy | Non-Identifying | One To Zero or More |  |  |  | StudentAreaOfStudyId | NO
AreaOfStudy | Non-Identifying | Zero or One to Zero or More |  |  |  | AreaOfStudyId | NO
ProgramVersionAreaOfStudy | Non-Identifying | Zero or One to Zero or More |  |  |  | ProgramVersionAreaOfStudyId | NO
StudentEnrollmentPeriod | Non-Identifying | One To Zero or More |  |  |  | StudentEnrollmentPeriodId | NO
Staff | Non-Identifying | One To Zero or More |  |  |  | LastModifiedUserId | NO
Staff | Non-Identifying | Zero or One to Zero or More |  |  |  | DropByUserId | NO
StudentAreaOfStudy | Non-Identifying | One To Zero or More |  |  |  | StudentAreaOfStudyId | NO
ProgramVersionAreaOfStudy | Non-Identifying | Zero or One to Zero or More |  |  |  | ProgramVersionAreaOfStudyId | NO
StudentEnrollmentPeriod | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentEnrollmentPeriodId | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype
StudentAreaOfStudy | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentAreaOfStudy | Non-Identifying | One To Zero or More |  |  |  |  | NO

StudentAreaOfStudy Check Constraints

Check Constraint Name | CheckConstraint

StudentAreaOfStudy Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.StudentAreaOfStudy | NO |  |  |
Physical (Microsoft SQL Server) dbo.AdConcentrationByEnrollment | NO |  |  |

StudentAreaOfStudy Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Logical | DegreePathway
Logical | StudentEnrollment
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Academic Records

StudentAreaOfStudy Data Movement Rules

Name | Type | Rule Text/Value